package com.engineering.elink.recruitdao;

import java.util.List;

import org.apache.ibatis.annotations.Select;

import com.engineering.elink.domain.recruit.MajorSecondCategory;

public interface MajorSecondCategoryMapper {
    int deleteByPrimaryKey(Integer mscId);

    int insert(MajorSecondCategory record);

    int insertSelective(MajorSecondCategory record);

    MajorSecondCategory selectByPrimaryKey(Integer mscId);

    int updateByPrimaryKeySelective(MajorSecondCategory record);

    int updateByPrimaryKey(MajorSecondCategory record);
    
    @Select(" select msc_id as mscId, mdc_id as mdcId, msc_name as mscName from major_second_category where mdc_id=#{mdcId} ")
    List<MajorSecondCategory> selectAllByMdcId(Integer mdcId);
}